CaptureForm Expression Builder

The Expression Builder allows you to manipulate variable values similar to CaptureForm SQL queries, but without the need for a database source. Here you can you specify the value by calculating an expression. You can define the properties of a CaptureForm expression using the fields below.

Expression Name
This is the name of the expression as it appears in the Process Tree. The expression name isn't used by FormFusion, but lets you create a descriptive name for the expression (such as "Get email address" or "Get vendor email address").

When should this expression execute?
This dropdown controls when the expression will execute.

• Pre - Executes before any data has been processed on the server side.
• Page - Executes before each page is processed. Note: Most expressions will be Page expressions.
• Post - Executes after the entire job is complete.
• Test - Prevents the expression from executing on the server.

Store results to variable
This dropdown contains a list of variables available from within variable storage. The variable selected will store the result of the expression defined within this CaptureForm Expression.

This expression should be used during sort (see help for more information)
To facilitate the sorting process you must specify which expression should be executed during the sort. This decreases program latency by only executing the expressions that you instruct FormFusion to execute. Sorting is performed before the processing of the report file is begun.

Terminate processing of the template if this query returns an error
Checking this checkbox will force FormFusion to terminate the current process being executed if an error occurs in this expression. If you want processing to continue regardless if there is an error in this expression, then leave this unchecked.

Type your expression:
This box is where you enter the expression that defines the actions for this CaptureForm expression.

Functions
Any function specified in this list may be used as part of the CaptureForm expression. Functions can be double-clicked or dragged to be placed in the Type your expression field. A description of each function can be viewed below the Functions list, including function parameter types and return types.

Test Expression
The Test Expression button (green triangle) allows you to test the expression you created without committing the results. After testing the expression you can save the results as sample data for preview within FormStamp.